package com.bishe.dao;

import com.bishe.pojo.Checkwork;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 考情数据层
 * @date 2022/03/20 42:08:04
 */
public interface CheckworkDao {

    @Select("select * from checkwork")
    List<Checkwork> findAll();


    @Select("select * from checkwork where id = #{id}")
    Checkwork findById(@Param("id") String id);

    @Delete("delete  from checkwork where id = #{id}")
    void deleteById(@Param("id") String id);


    @Update("update checkwork set id = #{id},content = #{content},createTime = #{createTime},createBy = #{createBy} where id = #{id}")
    void updateById(Checkwork checkwork);


    @Insert("insert into checkwork (id,content,createTime,createBy) values(#{id},#{content},#{createTime},#{createBy})")
    void save(Checkwork checkwork);
}
